Invalid Memo, OLE, or Hyperlink Object in subquery <name>. (Error 3342)

A subquery cannot return a Memo or OLE Object, and it cannot be compared to a Memo or OLE Object in an expression.